Case Study: Oxford
Analysis summary
You calculated the BNA score for Oxford, UK within a biking distance of 3 km.
The analysis took 19 minutes to run.
The analysis corresponds to the OSM boundary area (red) based on its Lower Layer Superoutput Areas (LSOA) (green).
Results
| |
Score/Value |
| Overall Score |
77.27 |
| Population |
182146 |
| Length of Low Stress Network (km) |
1559.8 |
| Length of High Stress Network (km) |
241.9 |
| People |
| Total People |
78.32 |
| Opportunity |
| Employment |
78.59 |
| K-12 Education |
83.88 |
| Technical/vocational school |
80.18 |
| Higher Education |
80.38 |
| Total Opportunity |
80.96 |
| Core Services |
| Doctor offices/clinics |
74.95 |
| Dentist offices |
72.38 |
| Hospitals |
71.96 |
| Pharmacies |
77.66 |
| Supermarkets |
87.28 |
| Social services |
74.93 |
| Total Core Services |
77.45 |
| Retail |
| Total Retail shopping |
83.2 |
| Recreation |
| Parks |
86.55 |
| Recreational trails |
92.89 |
| Community centers |
75.8 |
| Total Recreation |
86.08 |
| Transit |
| Total Transit |
56.35 |
Setup info
To run this analysis, the user should:
- Create a database on its PostgreSQL. To test connection an empty table on the database called “test” should be created on the public schema.
- Tip: Run FULL VACUUM/ANALYZE frequently to the database to improve performance.
- Follow the tips on this presentation to increase performance of the database.
Set path variables for osm2pgsql and osm2pgrouting.
Create a password file on %APPDATA%/postgresql/pgpass.conf with the format hostname:port:database:username:password
Data sources
|
Population |
Jobs |
| Region |
Source |
Description |
Source |
Description |
| US |
|
Not added yet. |
|
Not added yet. |
| Europe |
GEOSTAT - EUROSTAT |
Population grid per squared kilometer for 2011. |
|
No data available for the whole continent with high spatial resolution. |
| UK |
Office of National Statistics - UK |
Population estimates for mid-2017 at LSOA and MSOA level. |
Office of National Statistics - UK |
Flow commute data for the 2011 Census at LSOA and MSOA level, where the total number of trips per super-output area where aggregated. |
| The Netherlands |
CBS (Centraal Bureau voor de Statistiek) - NL |
District and neighborhood map with associated key figures for 2017. |
LISA (National Information System for Workplaces) dataset |
Jobs per municipality. To estimate jobs at neighborhood level an weighted estimation was made with the number of jobs in the whole municipality hafly weighted by the fraction of the neighborhood area, and hafly weighted by the fraction of companies in the neighborhood. This approach needs to be validated, however it is one way to approximate it, given that LISA data at this aggregation level has to be bought and is not open data. |
LS0tDQp0aXRsZTogIkJOQSBSZXBvcnQiDQpvdXRwdXQ6DQogIGh0bWxfbm90ZWJvb2s6DQogICAgaGlnaGxpZ2h0OiBoYWRkb2NrDQogICAgdGhlbWU6IGpvdXJuYWwNCi0tLQ0KDQpgYGB7ciBzZXR1cCwgaW5jbHVkZT1GQUxTRX0NCmtuaXRyOjpvcHRzX2tuaXQkc2V0KHJvb3QuZGlyID0gbm9ybWFsaXplUGF0aCgiLi4vIikpDQprbml0cjo6cmVhZF9jaHVuaygNCiAgIi4uL3NjcmlwdHMvYW5hbHlzaXMuUiINCikNCmBgYA0KDQojIENhc2UgU3R1ZHk6IGByIHNhX25hbWVgIHsudGFic2V0fQ0KDQojIyBBbmFseXNpcyBzdW1tYXJ5DQoNCmBgYHtyIGRhdGFiYXNlLCBpbmNsdWRlID0gRkFMU0V9DQpkYl9uYW1lID0gImJuYV9ldXJvcGUiDQpsb2NhbF9ob3N0ID0gImxvY2FsaG9zdCINCnBvcnRfbnVtID0gNTQzMg0KdXNlcl9uYW1lID0gInBvc3RncmVzIg0KZGJfcGFzcyA9ICJkYXM4NDEwIg0KYGBgDQoNCmBgYHtyIHZhcmlhYmxlcywgd2FybmluZyA9IEZBTFNFLCBpbmNsdWRlID0gRkFMU0V9DQojIyBCYXNpYyB2YXJpYWJsZXMgdG8gc2V0IA0KY291bnRyeSA9ICJVSyIgIyBQb3NzaWJsZSBvcHRpb25zOiBVSywgVVMsIEJlbGdpdW0sIE5ldGhlcmxhbmRzLCBOQQ0Kc2FfbmFtZSA9ICJPeGZvcmQiICMgc3R1ZHkgYXJlYQ0Kc2FfY3JzID0gMzg1NyAjIGNycw0KYmlraW5nX2Rpc3RhbmNlID0gMzAwMCAjIyBpbiBtZXRlcnMNCg0KYXJlYV90eXBlID0gIm9zbSIgIyMgcG9zc2libGUgb3B0aW9uczogIg0KICAgICAgICAgICAgICAgICAgIyMgIm9zbSIgZm9yIGFueSBjb3VudHJ5DQogICAgICAgICAgICAgICAgICAjIyAidHR3YSIgZm9yIHRoZSBVSw0KDQptaW5fYXJlYSA9ICJsc29hIiAjIyBwb3NzaWJsZSBvcHRpb25zOiANCiAgICAgICAgICAgICAgICAgICMjICJnZW9zdGF0IiBmb3IgYW55IGNvdW50cnksIA0KICAgICAgICAgICAgICAgICAgIyMgImxzb2EiIG9yICJtc29hIiBmb3IgdGhlIFVLDQogICAgICAgICAgICAgICAgICAjIyAiY2IiIGZvciB0aGUgVVMgKG5vdCB5ZXQpDQogICAgICAgICAgICAgICAgICAjIyAiYnV1cnQiIGZvciB0aGUgTmV0aGVybGFuZHMNCg0KIyMgSWYgdGhlIGFuYWx5c2lzIHJ1bnMgd2l0aCB0aGUgR0VPU1RBVCBwb3B1bGF0aW9uIGdyaWQgYXMgbWluX2FyZWENCnN1YmRpdmlzaW9ucyA9IDQNCmBgYA0KDQoqIFlvdSBjYWxjdWxhdGVkIHRoZSBCTkEgc2NvcmUgZm9yIA0KPHNwYW4gc3R5bGU9ImNvbG9yOiNCQjYxNkQiPioqYHIgc2FfbmFtZWAsIGByIGNvdW50cnlgKio8L3NwYW4+IA0Kd2l0aGluIGEgYmlraW5nIGRpc3RhbmNlIG9mIA0KPHNwYW4gc3R5bGU9ImNvbG9yOiNCQjYxNkQiPioqYHIgYmlraW5nX2Rpc3RhbmNlLzEwMDBgKio8L3NwYW4+IGttLg0KDQoqIFRoZSBhbmFseXNpcyB0b29rICoqYHIgcm91bmQoYXMubnVtZXJpYyhkdXJhdGlvbiksMilgIG1pbnV0ZXMqKiB0byBydW4uDQoNCiogVGhlIGFuYWx5c2lzIGNvcnJlc3BvbmRzIHRvIHRoZSANCjxzcGFuIHN0eWxlPSJjb2xvcjojQkI2MTZEIj4qKmByIGlmZWxzZShhcmVhX3R5cGUgPT0gInR0d2EiLCJUcmF2ZWwgdG8gV29yayBBcmVhIiwiT1NNIGJvdW5kYXJ5IGFyZWEiKWAqKjwvc3Bhbj4gKHJlZCkgYmFzZWQgb24gDQo8c3BhbiBzdHlsZT0iY29sb3I6I0JCNjE2RCI+KipgciBpZmVsc2UobWluX2FyZWEgPT0gIm1zb2EiLCJpdHMgTWlkZGxlIExheWVyIFN1cGVyb3V0cHV0IEFyZWFzIChNU09BKSIsaWZlbHNlKG1pbl9hcmVhID09ICJsc29hIiwiaXRzIExvd2VyIExheWVyIFN1cGVyb3V0cHV0IEFyZWFzIChMU09BKSIsaWZlbHNlKG1pbl9hcmVhID09ICJjYiIsIml0cyBjZW5zdXMgYmxvY2tzIixpZmVsc2UobWluX2FyZWEgPT0gImJ1dXJ0IiwiaXRzIG5laWdoYm9yaG9vZCBhcmVhcyIsImEgc3ViZGl2aWRlZCBwb3B1bGF0aW9uIGdyaWQgZnJvbSBHRU9TVEFUIikpKSlgKio8L3NwYW4+IChncmVlbikuDQoNCmBgYHtyIGFyZWEsIGluY2x1ZGU9RkFMU0UsIGNhY2hlID0gRkFMU0V9DQpgYGANCg0KYGBge3IgbmV0d29yaywgaW5jbHVkZSA9IEZBTFNFLCBjYWNoZSA9IEZBTFNFfQ0KYGBgDQoNCmBgYHtyIG1pbl9hcmVhLCBpbmNsdWRlID0gRkFMU0UsIGNhY2hlID0gRkFMU0V9DQpgYGANCg0KYGBge3IgcGxvdF9hcmVhLCBmaWcud2lkdGggPSA4LCBmaWcuaGVpZ2h0PSA1LCBlY2hvID0gRkFMU0UsIHdhcm5pbmcgPSBGQUxTRSwgbWVzc2FnZSA9IEZBTFNFfQ0KbGlicmFyeSh0bWFwKQ0KDQp0bWFwX21vZGUoInZpZXciKQ0KdG1hcF9sZWFmbGV0KA0KICAgICB0bV92aWV3KA0KICAgICBiYXNlbWFwcyA9ICJDYXJ0b0RCLlBvc2l0cm9uIg0KICAgKSArDQogICAgIHRtX3NoYXBlKG1pbl9hcmVhX2dyaWQpICsNCiAgICAgdG1fcG9seWdvbnMoDQogICAgICAgYm9yZGVyLmNvbCA9ICJncmVlbiIsDQogICAgICAgYWxwaGEgPSAwDQogICAgICApICsNCiAgICAgdG1fc2hhcGUoYm91bmRhcnkpICsNCiAgICAgdG1fcG9seWdvbnMoDQogICAgICAgYm9yZGVyLmNvbCA9ICJyZWQiLA0KICAgICAgIGFscGhhID0gMCwNCiAgICAgICBsd2QgPSA0DQogICAgICApIA0KKQ0KYGBgDQoNCmBgYHtyIHJlYWNoYWJsZV9yb2FkcywgaW5jbHVkZSA9IEZBTFNFLCBjYWNoZSA9IEZBTFNFfQ0KYGBgDQoNCmBgYHtyIGFjY2Vzc2liaWxpdHksIGluY2x1ZGUgPSBGQUxTRSwgY2FjaGUgPSBGQUxTRX0NCmBgYA0KDQpgYGB7ciBvdmVyYWxsX3Njb3JlLCBpbmNsdWRlID0gRkFMU0UsIGNhY2hlID0gRkFMU0V9DQpgYGANCg0KIyMgUmVzdWx0cw0KDQpgYGB7ciwgaW5jbHVkZSA9IEZBTFNFLCB3YXJuaW5nID0gRkFMU0V9DQojIyBDYWxsIGRhdGEgaW50byBSDQpsaWJyYXJ5KHNmKQ0KYm5hX3Njb3JlIDwtIHN0X3JlYWQoDQogIGRzbiA9IGNvbm5lY3Rpb24sDQogIGxheWVyID0gYygiZ2VuZXJhdGVkIiwic2FfcG9wX2dyaWQiKQ0KKQ0KDQpzdHJlc3NfbmV0d29yayA8LSBzdF9yZWFkKA0KICBkc24gPSBjb25uZWN0aW9uLA0KICBxdWVyeSA9ICJTRUxFQ1QgZnRfc2VnX3N0cmVzcywgdGZfc2VnX3N0cmVzcywgZ2VvbSBGUk9NIHJlY2VpdmVkLnNhX3dheXMiDQopDQoNCiMjIEVzdGFibGlzaCBjb2xvcnMgYW5kIGJyZWFrcyBmb3IgdGhlIEJOQSBkaXNwbGF5IGJhc2VkIG9uIHRoZSBQZkIgdmlzdWFsaXplcg0KYm5hX3BhbCA8LSBjKCIjRkM3MTUxIiwiI0RDN0U2QSIsIiNDOTg4NzUiLCIjQzA4QjgzIiwiI0FEOTM5NiIsDQogICAgICAgICAgICAgIiM5QzlBOUYiLCIjOTI5RUFDIiwiIzc4QUFDNSIsIiM2RkFEQ0IiLCIjNDlCRkU2IikNCg0KYm5hX2JyZWFrcyA8LSBjKDYsMTIsMTgsMjQsMzAsMzYsNDIsNDgsNTQsMTAwKQ0KDQpzdHJlc3NfbmV0d29yayRmdF9zdHJlc3MgPC0gaWZlbHNlKHN0cmVzc19uZXR3b3JrJGZ0X3NlZ19zdHJlc3MgPT0gMSwibG93IHN0cmVzcyIsImhpZ2ggc3RyZXNzIikNCnN0cmVzc19uZXR3b3JrJHRmX3N0cmVzcyA8LSBpZmVsc2Uoc3RyZXNzX25ldHdvcmskdGZfc2VnX3N0cmVzcyA9PSAxLCJsb3cgc3RyZXNzIiwiaGlnaCBzdHJlc3MiKQ0KDQojIyBDYWxsIHBsb3R0aW5nIGxpYnJhcnkgYW5kIHNldCB0byBtb2RlIHZpZXcNCmxpYnJhcnkodG1hcCkNCnRtYXBfbW9kZSgidmlldyIpDQpgYGANCg0KYGBge3IsIGZpZy53aWR0aCA9IDEwLCBmaWcuaGVpZ2h0PSA1LCBmaWcuYWxpZ24gPSAnY2VudGVyJywgZWNobyA9IEZBTFNFLCB3YXJuaW5nID0gRkFMU0V9DQppbnRfbWFwIDwtIA0KICB0bWFwOjp0bWFwX2xlYWZsZXQoDQogICAgIHRtYXA6OnRtX3ZpZXcoDQogICAgIGJhc2VtYXBzID0gYygNCiAgICAgICAiQ2FydG9EQi5Qb3NpdHJvbiIsDQogICAgICAgIkNhcnRvREIuRGFya01hdHRlciIsDQogICAgICAgIk9wZW5TdHJlZXRNYXAuTWFwbmlrIg0KICAgICApDQogICApICsNCiAgICAgdG1hcDo6dG1fc2hhcGUoYm5hX3Njb3JlKSArDQogICAgIHRtYXA6OnRtX3BvbHlnb25zKA0KICAgICAgIGNvbCA9ICJvdmVyYWxsX3Njb3JlIiwNCiAgICAgICBzdHlsZSA9ICJmaXhlZCIsDQogICAgICAgYnJlYWtzID0gYm5hX2JyZWFrcywNCiAgICAgICBwYWxldHRlID0gYm5hX3BhbCwNCiAgICAgICBhbHBoYSA9IDAuOCwNCiAgICAgICB0aXRsZSA9ICJCTkEgc2NvcmUiLA0KICAgICAgIGJvcmRlci5jb2wgPSBOVUxMLA0KICAgICAgIGNvbG9yTkEgPSBOVUxMLA0KICAgICAgIHNob3dOQSA9IEZBTFNFDQogICAgICApICsNCiAgICAgdG1hcDo6dG1fc2hhcGUoc3RyZXNzX25ldHdvcmspICsNCiAgICAgdG1hcDo6dG1fbGluZXMoDQogICAgICAgY29sID0gImZ0X3N0cmVzcyIsIA0KICAgICAgIGNvbG9yTkEgPSBOVUxMLA0KICAgICAgIHNob3dOQSA9IEZBTFNFLA0KICAgICAgIHBhbGV0dGUgPSBjKCJmaXJlYnJpY2sxIiwgImRlZXBza3libHVlMyIpLA0KICAgICAgIHRpdGxlLmNvbCA9ICJTdHJlc3MgbmV0d29yayINCiAgICAgICkgKw0KICAgICB0bWFwOjp0bV9zaGFwZShzdHJlc3NfbmV0d29yaykgKw0KICAgICB0bWFwOjp0bV9saW5lcygNCiAgICAgICBjb2wgPSAidGZfc3RyZXNzIiwgDQogICAgICAgY29sb3JOQSA9IE5VTEwsDQogICAgICAgc2hvd05BID0gRkFMU0UsDQogICAgICAgcGFsZXR0ZSA9IGMoImZpcmVicmljazEiLCAiZGVlcHNreWJsdWUzIiksDQogICAgICAgbGVnZW5kLmNvbC5zaG93ID0gRkFMU0UNCiAgICAgICkNCiAgKQ0KDQppbnRfbWFwDQpgYGANCg0KYGBge3IgZGlzcGxheV90YWJsZSwgaW5jbHVkZSA9IFRSVUUsIGVjaG8gPSBGQUxTRSwgY2FjaGUgPSBGQUxTRX0NCmBgYA0KDQpgYGB7ciBkdXJhdGlvbiwgaW5jbHVkZSA9IEZBTFNFLCBjYWNoZSA9IEZBTFNFfQ0KYGBgDQoNCiMjIFNldHVwIGluZm8NCg0KVG8gcnVuIHRoaXMgYW5hbHlzaXMsIHRoZSB1c2VyIHNob3VsZDoNCg0KMS4gQ3JlYXRlIGEgZGF0YWJhc2Ugb24gaXRzIFBvc3RncmVTUUwuIFRvIHRlc3QgY29ubmVjdGlvbiBhbiBlbXB0eSB0YWJsZSBvbiB0aGUgZGF0YWJhc2UgY2FsbGVkICJ0ZXN0IiBzaG91bGQgYmUgY3JlYXRlZCBvbiB0aGUgcHVibGljIHNjaGVtYS4gDQogICAgKyBUaXA6IFJ1biBGVUxMIFZBQ1VVTS9BTkFMWVpFIGZyZXF1ZW50bHkgdG8gdGhlIGRhdGFiYXNlIHRvIGltcHJvdmUgcGVyZm9ybWFuY2UuDQogICAgKyBGb2xsb3cgdGhlIHRpcHMgb24gW3RoaXMgcHJlc2VudGF0aW9uXShodHRwczovL3RoZWJ1aWxkLmNvbS9wcmVzZW50YXRpb25zL25vdC15b3VyLWpvYi5wZGYpIHRvIGluY3JlYXNlIHBlcmZvcm1hbmNlIG9mIHRoZSBkYXRhYmFzZS4NCg0KMi4gU2V0IHBhdGggdmFyaWFibGVzIGZvciBgb3NtMnBnc3FsYCBhbmQgYG9zbTJwZ3JvdXRpbmdgLg0KDQozLiBDcmVhdGUgYSBwYXNzd29yZCBmaWxlIG9uIGAlQVBQREFUQSUvcG9zdGdyZXNxbC9wZ3Bhc3MuY29uZmAgd2l0aCB0aGUgZm9ybWF0ICpob3N0bmFtZTpwb3J0OmRhdGFiYXNlOnVzZXJuYW1lOnBhc3N3b3JkKg0KDQoNCiMjIERhdGEgc291cmNlcw0KDQpgYGB7ciwgZWNobyA9IEZBTFNFfQ0KbGlicmFyeShrYWJsZUV4dHJhKQ0KdGJsIDwtIGRhdGEuZnJhbWUoDQogIFJlZ2lvbiA9IGNlbGxfc3BlYygNCiAgICBjKA0KICAgICAgIlVTIiwNCiAgICAgICJFdXJvcGUiLA0KICAgICAgIlVLIiwNCiAgICAgICJUaGUgTmV0aGVybGFuZHMiDQogICAgKQ0KICApLA0KICBzb3VyY2VfcG9wID0gY2VsbF9zcGVjKA0KICAgIGMoDQogICAgICAiIiwNCiAgICAgICJHRU9TVEFUIC0gRVVST1NUQVQiLA0KICAgICAgIk9mZmljZSBvZiBOYXRpb25hbCBTdGF0aXN0aWNzIC0gVUsiLA0KICAgICAgIkNCUyAoQ2VudHJhYWwgQnVyZWF1IHZvb3IgZGUgU3RhdGlzdGllaykgLSBOTCINCiAgICApLA0KICAgIGxpbmsgPSBjKA0KICAgICAgIiIsDQogICAgICAiaHR0cHM6Ly9lYy5ldXJvcGEuZXUvZXVyb3N0YXQvd2ViL2dpc2NvL2dlb2RhdGEvcmVmZXJlbmNlLWRhdGEvcG9wdWxhdGlvbi1kaXN0cmlidXRpb24tZGVtb2dyYXBoeS9nZW9zdGF0IiwNCiAgICAgICJodHRwczovL3d3dy5vbnMuZ292LnVrL3Blb3BsZXBvcHVsYXRpb25hbmRjb21tdW5pdHkvcG9wdWxhdGlvbmFuZG1pZ3JhdGlvbi9wb3B1bGF0aW9uZXN0aW1hdGVzIiwNCiAgICAgICJodHRwczovL3d3dy5jYnMubmwvbmwtbmwvZG9zc2llci9uZWRlcmxhbmQtcmVnaW9uYWFsL2dlb2dyYWZpc2NoZSUyMGRhdGEvd2lqay1lbi1idXVydGthYXJ0LTIwMTciDQogICAgKQ0KICApLA0KICBkZXNjX3BvcCA9IGNlbGxfc3BlYygNCiAgICBjKA0KICAgICAgIk5vdCBhZGRlZCB5ZXQuIiwNCiAgICAgICJQb3B1bGF0aW9uIGdyaWQgcGVyIHNxdWFyZWQga2lsb21ldGVyIGZvciAyMDExLiIsDQogICAgICAiUG9wdWxhdGlvbiBlc3RpbWF0ZXMgZm9yIG1pZC0yMDE3IGF0IExTT0EgYW5kIE1TT0EgbGV2ZWwuIiwNCiAgICAgICJEaXN0cmljdCBhbmQgbmVpZ2hib3Job29kIG1hcCB3aXRoIGFzc29jaWF0ZWQga2V5IGZpZ3VyZXMgZm9yIDIwMTcuIg0KICAgICkNCiAgKSwNCiAgc291cmNlX2pvYnMgPSBjZWxsX3NwZWMoDQogICAgYygNCiAgICAgICIiLA0KICAgICAgIiIsDQogICAgICAiT2ZmaWNlIG9mIE5hdGlvbmFsIFN0YXRpc3RpY3MgLSBVSyIsDQogICAgICAiTElTQSAoTmF0aW9uYWwgSW5mb3JtYXRpb24gU3lzdGVtIGZvciBXb3JrcGxhY2VzKSBkYXRhc2V0Ig0KICAgICksIA0KICAgIGxpbmsgPSBjKA0KICAgICAgIiIsDQogICAgICAiIiwNCiAgICAgICJodHRwczovL3dpY2lkLnVrZGF0YXNlcnZpY2UuYWMudWsvY2lkZXIvd2ljaWQvZG93bmxvYWRzLnBocD9ndWVzdD0xIiwNCiAgICAgICJodHRwczovL3d3dy5saXNhLm5sL2RhdGEvZ3JhdGlzLWRhdGEvb3ZlcnppY2h0LWxpc2EtZGF0YS1wZXItZ2VtZWVudGUiDQogICAgKQ0KICApLA0KICBkZXNjX2pvYnMgPSBjZWxsX3NwZWMoDQogICAgYygNCiAgICAgICJOb3QgYWRkZWQgeWV0LiIsDQogICAgICAiTm8gZGF0YSBhdmFpbGFibGUgZm9yIHRoZSB3aG9sZSBjb250aW5lbnQgd2l0aCBoaWdoIHNwYXRpYWwgcmVzb2x1dGlvbi4iLA0KICAgICAgIkZsb3cgY29tbXV0ZSBkYXRhIGZvciB0aGUgMjAxMSBDZW5zdXMgYXQgTFNPQSBhbmQgTVNPQSBsZXZlbCwgd2hlcmUgdGhlIHRvdGFsIG51bWJlciBvZiB0cmlwcyBwZXIgc3VwZXItb3V0cHV0IGFyZWEgd2hlcmUgYWdncmVnYXRlZC4iLA0KICAgICAgIkpvYnMgcGVyIG11bmljaXBhbGl0eS4gVG8gZXN0aW1hdGUgam9icyBhdCBuZWlnaGJvcmhvb2QgbGV2ZWwgYW4gd2VpZ2h0ZWQgZXN0aW1hdGlvbiB3YXMgbWFkZSB3aXRoIHRoZSBudW1iZXIgb2Ygam9icyBpbiB0aGUgd2hvbGUgbXVuaWNpcGFsaXR5IGhhZmx5IHdlaWdodGVkIGJ5IHRoZSBmcmFjdGlvbiBvZiB0aGUgbmVpZ2hib3Job29kIGFyZWEsIGFuZCBoYWZseSB3ZWlnaHRlZCBieSB0aGUgZnJhY3Rpb24gb2YgY29tcGFuaWVzIGluIHRoZSBuZWlnaGJvcmhvb2QuIFRoaXMgYXBwcm9hY2ggbmVlZHMgdG8gYmUgdmFsaWRhdGVkLCBob3dldmVyIGl0IGlzIG9uZSB3YXkgdG8gYXBwcm94aW1hdGUgaXQsIGdpdmVuIHRoYXQgTElTQSBkYXRhIGF0IHRoaXMgYWdncmVnYXRpb24gbGV2ZWwgaGFzIHRvIGJlIGJvdWdodCBhbmQgaXMgbm90IG9wZW4gZGF0YS4iDQogICAgKQ0KICApDQopDQoNCm5hbWVzKHRibCkgPC0gYygiUmVnaW9uIiwgIlNvdXJjZSIsICJEZXNjcmlwdGlvbiIsICJTb3VyY2UiLCAiRGVzY3JpcHRpb24iKQ0KDQprYWJsZSh0YmwsIGFsaWduID0gImMiLCBlc2NhcGUgPSBGQUxTRSkgJT4lDQogIGthYmxlX3N0eWxpbmcoInN0cmlwZWQiLCAiYm9yZGVyZWQiLCBmb250X3NpemUgPSAxMCwgZnVsbF93aWR0aCA9IFQpICU+JSANCiAgYWRkX2hlYWRlcl9hYm92ZShjKCIgIiwgIlBvcHVsYXRpb24iID0gMiwgIkpvYnMiID0gMikpICU+JSANCiAgY29sdW1uX3NwZWMoMywgd2lkdGhfbWF4ID0gIjEwY20iKSAlPiUgDQogIGNvbHVtbl9zcGVjKDUsIHdpZHRoX21heCA9ICIxMGNtIikNCmBgYA0KDQo=